﻿CREATE TABLE [dbo].[AW_DocTakeUpRent] (
    [DocRentId]             UNIQUEIDENTIFIER NULL,
    [DocRentTitle]          NVARCHAR (250)   NULL,
    [DocOpenRefNo]          NVARCHAR (250)   NULL,
    [TransactionId]         UNIQUEIDENTIFIER NULL,
    [Category]              NVARCHAR (50)    NULL,
    [REN]                   NVARCHAR (500)   NULL,
    [Lister]                NVARCHAR (500)   NULL,
    [DocDate]               DATETIME         NULL,
    [Premise]               NVARCHAR (500)   NULL,
    [MonthlyRental]         DECIMAL (18, 2)  NULL,
    [Duration]              DECIMAL (18, 2)  NULL,
    [DurationType]          NVARCHAR (50)    NULL,
    [AnotherDuration]       DECIMAL (18, 2)  NULL,
    [AnotherType]           NVARCHAR (50)    NULL,
    [UponAt]                NVARCHAR (50)    NULL,
    [Increase]              DECIMAL (18, 2)  NULL,
    [CommencementDate]      DATETIME         NULL,
    [PremisesUse]           NVARCHAR (250)   NULL,
    [TerminationClause]     NVARCHAR (MAX)   NULL,
    [RentFreePeriod]        NVARCHAR (250)   NULL,
    [Requisition]           NVARCHAR (MAX)   NULL,
    [LandlordName]          NVARCHAR (500)   NULL,
    [LandlordNRIC]          NVARCHAR (250)   NULL,
    [LandlordAddress]       NVARCHAR (500)   NULL,
    [LandlordContactPerson] NVARCHAR (250)   NULL,
    [LandlordTel]           NVARCHAR (250)   NULL,
    [LandlordFax]           NVARCHAR (250)   NULL,
    [LandlordMobile]        NVARCHAR (250)   NULL,
    [LandlordVMT]           NVARCHAR (250)   NULL,
    [AgencyFee]             DECIMAL (18, 2)  NULL,
    [GovTax]                DECIMAL (18, 2)  NULL,
    [GovPercent]            DECIMAL (18, 2)  NULL,
    [LandlordTA]            DECIMAL (18, 2)  NULL,
    [LandlordStampingFee]   DECIMAL (18, 2)  NULL,
    [BankAcc]               NVARCHAR (250)   NULL,
    [TenantName]            NVARCHAR (500)   NULL,
    [TenantNRIC]            NVARCHAR (250)   NULL,
    [TenantAddress]         NVARCHAR (500)   NULL,
    [TenantContactPerson]   NVARCHAR (250)   NULL,
    [TenantTel]             NVARCHAR (250)   NULL,
    [TenantFax]             NVARCHAR (250)   NULL,
    [TenantMobile]          NVARCHAR (250)   NULL,
    [TenantVMT]             NVARCHAR (500)   NULL,
    [DepositMonth]          DECIMAL (18, 2)  NULL,
    [Deposit]               DECIMAL (18, 2)  NULL,
    [AdvanceMonth]          DECIMAL (18, 2)  NULL,
    [Advance]               DECIMAL (18, 2)  NULL,
    [WEDeposit]             DECIMAL (18, 2)  NULL,
    [Disbursement]          DECIMAL (18, 2)  NULL,
    [TenantTA]              DECIMAL (18, 2)  NULL,
    [TenantStampingFee]     DECIMAL (18, 2)  NULL,
    [ReferralFee]           DECIMAL (18, 2)  NULL,
    [CreateDate]            DATETIME         NULL,
    [CreateBy]              UNIQUEIDENTIFIER NULL,
    [UpdateDate]            DATETIME         NULL,
    [UpdateBy]              UNIQUEIDENTIFIER NULL,
    [StatusDelete]          TINYINT          NULL
);

